1、 查：show
mysql> show create database second_database;
+-----------------+--------------------------------------------------------------- ----------------------------------------------------------------------------+
| Database | Create Database |
+-----------------+--------------------------------------------------- ----------------------------------------------------------------------------------------+
| second_database | CREATE DATABASE `second_database` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */ |
+-----------------+----------------------------------------- --------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)